Labels:chat room | crt screen | hakham | monitor | plant | sky OCR: 648 SECTION D CHAPTER 11 SEARCHING FOR INFORMATION How do SQL queries carry out searches? One of the most com- mon database operations is query for particular record do group of records by using the SELECT command Suppose you're looking for Jefferson Airplane albums You fill in the Search box at the Vintage Music Shop site as shown in Figure FIGURE 11-48 Search Search form used by customers Artist: Jefferson Airplane to query the database. Here the Title: search S for Jefferson Airplane Label: albums. Format LP CCassette CSingle Search Now Clearthe Form The database client software uses your search specification to create the SQL query: SEL ECT Album Title AlbumCover FROM Albums WHERE ArtistName Jefferson Airplane As result of this query, the Vintage Music Shop Web page displays list begin ...
